SELECT FORMMAIN_1003."ID",FORMMAIN_1003.FIELD0013 assetNo,FORMMAIN_1003.FIELD0014 assetName, fl.SHOWVALUE as type,zq.SHOWVALUE as time FROM COL_SUMMARY 
LEFT JOIN FORMMAIN_1003 ON FORMMAIN_1003."ID" = COL_SUMMARY.FORM_RECORDID
LEFT JOIN CTP_ENUM_ITEM fl ON fl."ID" = FORMMAIN_1003.FIELD0006
LEFT JOIN CTP_ENUM_ITEM zq ON zq."ID" = FORMMAIN_1003.FIELD0007
WHERE COL_SUMMARY."ID" = '${id}'